SELECT T.*, JDT.NAME AS TYPE_NA
FROM FD_DICTIONARY T
JOIN FD_DICTIONARY_TY JDT ON (JDT.ID = T.TYPE_ID)
WHERE T.ID                           =:ID